<?xml version="1.0" encoding="utf-8" ?>
<Vulcan xmlns="http://tempuri.org/vulcan2.xsd">
  <Connections>
    <Connection Name="TestConnection1" Type="OleDB" />
  </Connections>
  <Packages>
    <Package Name="TestTable1" Type="Table">
      <Tasks>
        <ExecuteSQL Name="CreateTable" ConnectionName="TestConnection1">
          <Query QueryType="Standard">
            <Body>
              SET ANSI_NULLS ON
              SET QUOTED_IDENTIFIER ON
              GO

              -------------------------------------------------------------------
              IF EXISTS (SELECT * from sys.objects WHERE object_id = OBJECT_ID(N'[TestTable1]') AND type IN (N'U'))
              DROP TABLE [TestTable1]
              GO

              CREATE TABLE [TestTable1]
              (
              -- Columns Definition
              [Column1] int NOT NULL
              ,[Column2] int NOT NULL
              ,[VersionNumber] rowversion NOT NULL

              -- Constraints

              )
              ON [PRIMARY]
              WITH (DATA_COMPRESSION = NONE)
              GO

              -------------------------------------------------------------------
            </Body>
          </Query>
        </ExecuteSQL>
      </Tasks>
    </Package>
    <Package Name="TestTableClone" Type="Table">
      <Tasks>
        <ExecuteSQL Name="CreateTableClone" ConnectionName="TestConnection1">
          <Query QueryType="Standard">
            <Body>
              SET ANSI_NULLS ON
              SET QUOTED_IDENTIFIER ON
              GO

              -------------------------------------------------------------------
              IF EXISTS (SELECT * from sys.objects WHERE object_id = OBJECT_ID(N'[TestTableClone]') AND type IN (N'U'))
              DROP TABLE [TestTableClone]
              GO

              CREATE TABLE [TestTableClone]
              (
              -- Columns Definition
              [Column3] int NOT NULL
              ,[Column1] int NOT NULL
              ,[Column2] int NOT NULL
              ,[VersionNumber] rowversion NOT NULL

              -- Constraints

              )
              ON [PRIMARY]
              WITH (DATA_COMPRESSION = NONE)
              GO

              -------------------------------------------------------------------
            </Body>
          </Query>
        </ExecuteSQL>
      </Tasks>
    </Package>
  </Packages>
</Vulcan>